﻿CREATE TABLE [flcr].[CONTRACT] (
    [CONTRACT_ID]       INT              IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]        VARCHAR (100)    NOT NULL,
    [AUDIT_DTTM]        DATETIME         NOT NULL,
    [AUDIT_DTTM_TZ]     INT              NOT NULL,
    [AUDIT_MOD_USER]    VARCHAR (100)    NOT NULL,
    [AUDIT_MOD_DTTM]    DATETIME         NOT NULL,
    [AUDIT_MOD_DTTM_TZ] INT              NOT NULL,
    [RLS_MASK]          VARBINARY (256)  NULL,
    [RLS_OWNER]         UNIQUEIDENTIFIER NULL,
    [BUILTIN]           BIT              NOT NULL,
    [WRKFL_ITEM_ID]     INT              NOT NULL,
    [WRKFL_STATUS_ID]   INT              NOT NULL,
    [ACTIVE_FLG]        BIT              NOT NULL,
    [CONTRACT_NAME]     VARCHAR (50)     NOT NULL,
    [CONTRACT_TYPE]     INT              NOT NULL,
    [DOMAIN_ID]         INT              NOT NULL,
    [SUPPLIER_ID]       INT              NOT NULL,
    [PARENT_ID]         INT              NULL
);



